--249216
--249781
SELECT COUNT(*)
  FROM [RD_COMMON].[dbo].[Sales_Star_Customer]
  WHERE [ShiptoNumber] IN (7125008)


select * FROM [RD_COMMON].dbo.Star_AddressBook
where AddressNumber in (7125008)
--296848

select COUNT(*) FROM [RD_COMMON].dbo.Star_AddressBook




--- from DWCR
select * FROM 
RD_DWCR.DBO.JDEABADDRESSBOOKWHOSWHO
where addressnumber in (7125008) 

select COUNT(*) from RD_DWCR.dbo.JDEABAddressBookMaster

--296843
--296851
select COUNT(*) FROM 
RD_DWCR.DBO.JDEABADDRESSBOOKMASTER
where addressnumber in (7125008) 